package com.company.project.mapper.ldjsc.home;


import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.company.project.entity.ldjsc.home.CockpitContentEntity;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 *
 *
 * @author wenbin
 * @email *****@mail.com
 * @date 2025-08-11 18:08:24
 */
@Mapper
public interface CockpitContentMapper extends BaseMapper<CockpitContentEntity> {

    @Select("select * from page.cockpit_content where prefix_title = '经济监测报告' and source_from = '省发改委' ORDER BY create_time desc limit 0,1;")
    CockpitContentEntity selectByPrefixTitle();

    @Select("select * from page.cockpit_content where index_name = '领导关注' and source_from = '省国资委' ORDER BY create_time desc limit 0,1;")
    CockpitContentEntity selectByIndexName();

    @Select("select id,title,source_from,content_url,image_url,vedio_url,state,create_time,creator,update_user,update_time,publish_time,publisher,type_code,type_name,dept_name,dept_code,index_code,index_name,month,type_id,show_main_page,prefix_title,is_new,new_sq,main_sq,type_sq,sort " +
            "from cockpit_content where title like '%五应五不%' order by update_time desc;")
    List<CockpitContentEntity> selectByTitle();
}
